Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Partner
Partner

Re: Two Fields into one Field as Filter

It would do it automatically Beck :

In fact :

let's imagine I have this now:

table:

Crosstable (OptionField, ProjectManager) LOAD * INLINE [

Project,   Project_Manager1,    Project_Manager2 , Project_Manager3 , Proj Manager 4 , Projman

A,               Mike,                     Simon , Omar , Omar , Omar

B,               Tom,                      Frank , Omar , Omar , Omar

C ,               Yoko  ,                      Will , Omar , Omar , Omar

];

drop Field OptionField from table;

Result:

Capture.PNG

beck_bakytbek
Honored Contributor

Re: Two Fields into one Field as Filter

Omar, i mean this situation,

table1:

load * inline [

Project, ProjectManager

A, Takeshi

B,  James

D, Kate

](delimiter is ',');

table:

Crosstable (OptionField, ProjectManager) LOAD * INLINE [

Project,   Project_Manager1,    Project_Manager2

A,               Mike,                   Simon

B,               Tom,                    Frank

C ,              Yoko  ,                 Will

];

drop Field OptionField from table

what do you thin about it?

Thank a lot

Beck

Partner
Partner

Re: Two Fields into one Field as Filter

if u keep like this, it will create a synthetic key, but u'll have the right information; to eliminate the synthetic key, proceed as follow:

table1:

load * inline [

Project, ProjectManager

A, Takeshi

B,  James

D, Kate

](delimiter is ',');

 

table:

Crosstable (OptionField, ProjectManager) LOAD * INLINE [

Project,   Project_Manager1,    Project_Manager2

A,               Mike,                   Simon

B,               Tom,                    Frank

C ,              Yoko  ,                 Will

];

drop Field OptionField from table;

Final:

NoConcatenate

Load * Resident table;

Concatenate

load * Resident table1;

Drop Tables table,table1;

Exit Script;

result:

Capture.PNG

beck_bakytbek
Honored Contributor

Re: Two Fields into one Field as Filter

Thanks a lot Omar