Emmanuel Katto Dubai : How do I concatenate Source and Target values in Qlik to create a dynamic flow path column?
Hello Qlik Community,
I’m Emmanuel Katto from Dubai, United Arab Emirates (UAE) working with a dataset that includes the following columns: Source_code, Source, target_code, target, and data_type. My goal is to dynamically generate a new column called Path, which represents the flow from Source to Target, combining all possible connections in the correct order. Essentially, I want to concatenate the sources and targets as they connect in sequence to form a complete flow path.
Has anyone tackled this type of problem before? Any guidance on how to approach it in Qlik would be greatly appreciated!
