Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have two tables. One is a list of dealers. The other is a list of products. I want to create one table that has a row for each dealer and each product. What is the best way to do this in Qlik Sense?
Table 1 (dealer)
Table 2 (products)
Thanks in advance!
Go to Solution.
From Table 1 (dealer)
Table 2 (product)
That would do a cross join. If you need to relate specific products to specific vendors you need to create a key field between the two tables.
¿How are the two tables relating to each other? ¿Which is the key?
¿Are you asking to do it by script or in the frontend?
They are not related now. I would like to do this by script to create a table so I can then relate it to other existing tables.
Try this too
load concat(Field2,',') as A;
LOAD * INLINE [Field2123];let x= peek('A');
r:LOAD * INLINE [Field1ABC];
load Field1 as Field4,subfield('$(x)',',') as Field3resident r ;
Thanks. This appears to have worked as I need it to.