topic Concat data without circular loop in QlikView https://community.qlik.com/t5/QlikView/Concat-data-without-circular-loop/m-p/55180#M767207 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>i have 4 tables connected with each other like below</P><P></P><P>table - fields</P><P>---------------------</P><P>table1 - key1, f1</P><P>table2 - key1, key2</P><P>table3 - key2,key3</P><P>table4 - key3, f4</P><P></P><P></P><P>now i want a new field with the name NEW_FIELD with the data from f1 and f2 fields</P><P>Ex: f1 has values a,b,c</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; f2 has values d,e,f</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; then NEW_FIELD should have data as a,b,c,d,e,f</P><P></P><P>how should i achieve this without syn.keys/circular loops ?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT mohan2391 2020-11-25T16:16:04Z Concat data without circular loop https://community.qlik.com/t5/QlikView/Concat-data-without-circular-loop/m-p/55180#M767207 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>i have 4 tables connected with each other like below</P><P></P><P>table - fields</P><P>---------------------</P><P>table1 - key1, f1</P><P>table2 - key1, key2</P><P>table3 - key2,key3</P><P>table4 - key3, f4</P><P></P><P></P><P>now i want a new field with the name NEW_FIELD with the data from f1 and f2 fields</P><P>Ex: f1 has values a,b,c</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; f2 has values d,e,f</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; then NEW_FIELD should have data as a,b,c,d,e,f</P><P></P><P>how should i achieve this without syn.keys/circular loops ?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Concat-data-without-circular-loop/m-p/55180#M767207 mohan2391 2020-11-25T16:16:04Z