https://community.qlik.com/t5/Data-Movement-Streaming/Emmanuel-Katto-Dubai-How-do-I-concatenate-Source-and-Target/m-p/2491012#M2798 <P>Hello Qlik Community,</P> <P>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.</P> <P>Has anyone tackled this type of problem before? Any guidance on how to approach it in Qlik would be greatly appreciated!</P> <P>Regards</P> <P><STRONG>Emmanuel Katto&nbsp;</STRONG></P> Wed, 19 Mar 2025 21:48:59 GMT emmanuelkatto24 2025-03-19T21:48:59Z https://community.qlik.com/t5/Data-Movement-Streaming/Emmanuel-Katto-Dubai-How-do-I-concatenate-Source-and-Target/m-p/2491012#M2798 <P>Hello Qlik Community,</P> <P>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.</P> <P>Has anyone tackled this type of problem before? Any guidance on how to approach it in Qlik would be greatly appreciated!</P> <P>Regards</P> <P><STRONG>Emmanuel Katto&nbsp;</STRONG></P> Wed, 19 Mar 2025 21:48:59 GMT https://community.qlik.com/t5/Data-Movement-Streaming/Emmanuel-Katto-Dubai-How-do-I-concatenate-Source-and-Target/m-p/2491012#M2798 emmanuelkatto24 2025-03-19T21:48:59Z