Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I need your Support please.
Do you know how can I avoid $SYNC this tables automatically?
Take a look at my code:
like this:
Facts:
LOAD
your fields
FROM [lib://Miguel/Qlik\Luis.sales.invoice.line.*.qvd]
(qvd);
*
Concatenate (Facts)
LOAD
your fields
FROM [lib://Miguel/Qlik\Luis.hist.abono.venta.*.qvd]
(qvd);
(You can use file.* to load all files starting with same name)
Regards
This should work - https://www.analyticsvidhya.com/blog/2014/12/remove-synthetic-key-concatenation-link-table-qlikview/
You have to concatenate all (fact) tables into one table.
So will have filled the customer no from all tables and the document no also but there are different value fields like line amount and amount, depending on your source type.
Regards
Hi!
Thank you for your Support.
So, I´ve to concatenate the two tables at the same time?
Best regards.
like this:
Facts:
LOAD
your fields
FROM [lib://Miguel/Qlik\Luis.sales.invoice.line.*.qvd]
(qvd);
*
Concatenate (Facts)
LOAD
your fields
FROM [lib://Miguel/Qlik\Luis.hist.abono.venta.*.qvd]
(qvd);
(You can use file.* to load all files starting with same name)
Regards
This should work - https://www.analyticsvidhya.com/blog/2014/12/remove-synthetic-key-concatenation-link-table-qlikview/
Hi!
I've done this and perfect. I think is easy and helps a lot to avoid wrong sync's.
Thank you very much. Appreciate.