Forum Discussion
Cross reference table column with multiple values in Fabric Dataflow
Hello, We are working on dataflow in fabric and running into a problem, where we were unable to look up information dynamically. Eg: We have Tbl_ref which has following info ref_ID ref_type Sys...
Are there only ever two possible values in the REF_TYPE column - 'Cg' and 'Cg_part'? If so you could do a single merge and then pivot the data so the two rows for Cg and Cg_part become two columns. I don't know if that would perform better than two separate merges though.
Hi newtofabric
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.
In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.
Thanks.