Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone ,
I stuck in the requirement ,looking for your suugestion
Table A have list of data for different column but the name of this data column should assign on the basis of the Name present in Table B i.e. Data_1 should be changed as Country and Data_2 as Product ,
If the name of Data_1 is change as XXX in Table B ,then it should automatically changed in the output table
Table A :
Data_1 | Data_2 | Data_3 | Data_4 | Data_5 | Data_6 | Data_7 |
US | A | 100 | Bread | |||
IN | B | 200 | chocolate | |||
PAK | C | 300 | Pen |
Table B :
Group | Name |
Data_1 | Country |
Data_2 | Product |
Data_3 | Qty |
Data_4 | Name |
Data_5 | |
Data_6 | |
Data_7 |
Required output
Country | Product | Qty | Name | Data_5 | Data_6 | Data_7 |
US | A | 100 | Bread | |||
IN | B | 200 | chocolate | |||
PAK | C | 300 | Pen |
Please find the sample qvw
Hi
If your field name is constant then you can simply give the lable name
or if you want to go for mapping then try this
How to Rename Fields using Mapping Table
How to rename a field in qlikview
hope it helps
Hi
If your field name is constant then you can simply give the lable name
or if you want to go for mapping then try this
How to Rename Fields using Mapping Table
How to rename a field in qlikview
hope it helps
thanks deepak for frequent reply
I want to hide those fields at front end which are not present in Mapping table
Hi Try this
Hi,
try this,
t1:
LOAD * INLINE [
Data_1,Data_2,Data_3
US, A, 100, Bread
IN, B, 200, chocolate
PAK, C, 300, Pen
];
MapRenameFields:
Mapping LOAD Group,Name;
LOAD * Inline [
Group, Name
Data_1, Country
Data_2, Product
Data_3, Qty
Data_4, Name
];
RENAME Fields using MapRenameFields;
this will not work ..please try to learn the scenario
As per my scenario
Data_5, | |
Data_6, |
Data_7,
should be present at backend but not at front end.
Data_5 will display automatically when Name is present for Data_5
This worked like a charm! Thank you!
Hi,
I am facing a similar issue with the tables in Qliksense. Is there anyway you can provide me the code on how to resolve this. I am unable to open the file/app you shared.
I am uploading my files, if you can help me with resolving this as I am working in Qliksense, would be great.
Thanks,
Runelle