Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Concat

I have a table which contain following fields:

FormId ,FirstSubmtDate and SubmitDate.

I want to concat the value in Submit Date column, group by formId but i don"t want  the values in concat result which are in firstsubmitdate column.

Please help its really urgent.

4 Replies
jagannalla
Partner - Specialist III
Partner - Specialist III

T1:

Load FormId ,FirstSubmtDate,SubmitDate

From

SourceData;

Res:

Load FormId,

          FormId & SubmitDate as SubmitDate1,

          Count(FormId) as CountFormId

Resident T1

Group By FormId,SubmitDate ;

Not applicable
Author

can we do the same by using exists clause ????? if yes then plz explain

jagannalla
Partner - Specialist III
Partner - Specialist III

for exist clause we required field to compare..

Exists:

These functions are used when a value from previously loaded records of data is needed for the evaluation of the current record.

For eg:

Res:

Load FormId,

          FormId & SubmitDate as SubmitDate1,

          Count(FormId) as CountFormId

Resident T1

Where exist where exists (SubmitDate)

Group By FormId,SubmitDate ;

jagannalla
Partner - Specialist III
Partner - Specialist III

I think you want this code..

T1:

Load FormId ,FirstSubmtDate,SubmitDate

From

SourceData;

Res:

Load FormId,

          FormId & SubmitDate as SubmitDate1,

          Count(FormId) as CountFormId

Resident T1

where exists (SubmitDate,FormId & SubmitDate)

Group By FormId,SubmitDate ;