topic Fields not syncing in the table in QlikView

Fields not syncing in the table

karan_kn — Wed, 12 Jun 2019 13:51:34 GMT

Fields are not syncing when I use if condition

Script:

Table:
LOAD ID,
key,
value,
If(key='A', source_value) as FieldA,
If(key='B', source_value) as FieldB,
If(key='C', source_value) as FieldC;
SQL SELECT *
FROM dbo.Table1;

Output:

Re: Fields not syncing in the table

dplr-rn — Wed, 12 Jun 2019 14:32:12 GMT

With your code you still have 3 different rows rather than combining them into 1 single row.
What you are asking for is the opposite of crosstable load. so you need generic load.
check below link for details
https://community.qlik.com/t5/Qlik-Design-Blog/The-Generic-Load/ba-p/1473470

Re: Fields not syncing in the table

rubenmarin — Wed, 12 Jun 2019 15:06:35 GMT

Or use a group by or even applymap but as Dilipranjith says original data has 3 rows, so 3 rows are loaded and something has to be done to merge in one row.