Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Team,
i stuck a requirement.i have one table where two date's fields. i want to make them a common date.How is possible.kindly help me for resolving this issue.for this i am sharing data.
In data two field delviery date and doc date. i want to make them one field this is common date(Link Date)
Still be waiting.
maybe you can create a common date field in your table like this (doubling the records!):
SET DateFormat='DD.MM.YYYY';
table1:
LOAD RecNo() as ID,
[Doc. Date],
[Del. Date],
SubField([Doc. Date]&'@'&[Del. Date],'@') as Date,
Purch.Doc.,
Article,
PGr,
Item,
Num#([Net price],'#,##,##,###.##') as [Net price],
Num#(Quantity,'#,##,##,###.##') as Quantity,
Num#([Net Value],'#,##,##,###.##') as [Net Value],
Num#([GR Qty],'#,##,##,###.##') as [GR Qty]
FROM
(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);
hope this helps
regards
Marco
Glad you liked it.
Please close your thread if your question is answered:
Qlik Community Tip: Marking Replies as Correct or Helpful
thanks
regards
Marco