Discussion board where members can get started with QlikView.
Please tell me how to make Key between 2 tables having data as::
I have to make Key between Table A and Table B with Header 1 column...Plz show me the right way to do that...
* from TableA;
subfield(Header1,',') as key
PFA sample application Hope this will definitely help you.
that depends on which record from table_B you want to get joined/ linked to which record in table_A.
Generally, you can split the strings (pieces of text) in that header_field by using either of the string functions
- SPLITFIELD() (might be best if you know that your separator is always a ',')
=> Load the result as a new field which has to have the same name as the field_to_link_to in the other table - QlikView automatically links fields that have the same name.
load [Header 1] as Key,[Header 2], [Header 3] from table1;
subfield(Header,',') as Key,
[Header 2],[Header 3] from table 2;