Data Flow Derived Column

Question

Data Flow Derived Column

Sharukh Kundagol 145

Hi Team, I have a dataflow which takes 3 paramters as schema,table and column name. dataflow has derieved activity which append(concat($col,"1")) some string say '1' to the column name that we passed. but when i am running validating the data flow with below details schema -- 'aaa' table --'bbb' column -- 'Retry_count' it is giving data like 'Retry_count1' which is taking column as string value rather than actual column User's image

but when i am passing as below it is throwing error schema -- 'aaa' table --'bbb'

column -- Retry_count

User's image

Error: but column is there in the table User's image

1 answer

Your answer

Answer 1

Subashri Vasudevan 11,231

Hi Sharukh Kundagol Debug settings window lets you provide temporary value to the data flow parameters , with which you can do a debug preview of data.

Having said that, the value you pass to column -- Retry_count is not valid. You have to enclose the Retry_Count inside single quote. like 'Retry_count', same way how you pass aaa, bbb.

If you dont want to pass anything to Col, simply pass '' in the debug settings. This will make sure you can debug the data flow without errors. If you have further question or need more explanation, please do let us know. Thanks

Sharukh Kundagol 145 Reputation points

2024-02-05T10:04:56.57+00:00

Thanks for you reply, as i menditoned in question, when I pass col in single quote it is considering as string and output is 'Retry_Count1' it is not taking column from the table
Subashri Vasudevan 11,231 Reputation points

2024-02-07T07:07:40.19+00:00

How are you using the col in your derived column? Could you please let us know. I believe you can use the column name directly instead of passing via param. But to understand the issue better please let us know how you are using these params.

Share via

Data Flow Derived Column

1 answer

Your answer