Concat

[#1]

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.

[jagannalla]

T1:

Load FormId ,FirstSubmtDate,SubmitDate

From

SourceData;

Res:

Load FormId,

          FormId & SubmitDate as SubmitDate1,

          Count(FormId) as CountFormId

Resident T1

Group By FormId,SubmitDate ;

[#3]

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

[jagannalla]

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]

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 ;