NoConcatenation , Resident Load & String function - Qliksense

[Ranjanac]

I wanted to use String functions along with Resident Load and Non catenate to see the output .

But, this code is not working, What is the correct solution for this?

Attached Data & Load script editor code.

[Lokesh_5045]

As per my understanding, you want to map Maxprice and Minprice fields to Product1 table from Order table. Try using left join

Below Product1 script

Left join (Product1)
ProductID,
MinPrice,
MaxPrice
Resident Order;

Change the field names to avoid synthetic key.

[rubenmarin]

Hi, resident is to use an already loaded table as source, you can't use From and resident in the same sentence, noly one source.

Besides that 'NoConcatenate' is used to avoid autoconcatenation, this is when two tables has the same field names, in that case Qlik loads the 2nd table as additional rows to the first table, and NoConcatenation forces to keep it as two separated tables. In your example the tables has differnt field names, so NoConcatenation has no use there.

I don't know what are you trying to do here. Why is the resident on the Product1? Maybe you want a Join? Or an Exists()?

[BrunPierre]

@Ranjanac What should be the resultant table?