Azure / Azure/Azure-DataFactory

Dataflow derive column from parameter Error DF-EXPR-013

Open
#150 2 comments 0 reactions 0 assignees View on GitHub
Dominant language
PowerShell
Stars
529
Forks
623
PR merge metrics
No merged PRs in 30d

Description

I have a dataflow with a int parameter "CableStationNumber"

When I use a Derive Column action to make a CableStationNumber column with the value equal to $CableStationNumber (the data flow parameter) I get a DF-EXPR-013 Incompatible datatypes between declared type and actual parameter value.

As a result in my sink, I get a DF-EXPR-010 DF-EXPR-010 at Sink 'sink1'(Line 58/Col 18): Column 'CableStationNumber' not found. The stream is either not connected or column is unavailable.

The preview data shows everything correctly from source to sink, but when I debug the actual dataflow, I get the errors.

When I set CableStationNumber to an actual int like 123, it works. Please advise.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.