Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Godtooro
Contributor II
Contributor II

How yo avoid $SYNC tables

Dear all,

I need your Support please. 

Do you know how can I avoid $SYNC this tables automatically?

Take a look at my code:

 

LOAD
    "Document No_",
    "Sell-to Customer No_",
//     "Type",
    No_ as [Artículo],
//     "Shipment Date",
    Quantity,
    "Unit Price",
    "Unit Cost (LCY)",
//     "VAT _",
    "Line Discount _",
    "Line Discount Amount",
    Amount,
//     "Amount Including VAT",
//     "Allow Invoice Disc_",
//     "Inv_ Discount Amount",
//     "Gen_ Bus_ Posting Group",
    "Gen_ Prod_ Posting Group" as [Grupo contable inventario],
    "Unit Cost",
    "Line Amount",
    "Posting Date",
//     "Allow Line Disc_",
//     "Customer Disc_ Group",
    "_ Dto cabecera pedido",
    "Importe Dto_ Lin_ Factura"
//     "Order Date",
//     "Discount Code",
//     "Gross Amount"
FROM [lib://Miguel/Qlik\Luis.sales.invoice.line.2019.qvd]
(qvd);
Concatenate (Luis.sales.invoice)
LOAD
    "Document No_",
    "Sell-to Customer No_",
//     "Type",
    No_ as [Artículo],
//     "Shipment Date",
    Quantity,
    "Unit Price",
    "Unit Cost (LCY)",
//     "VAT _",
    "Line Discount _",
    "Line Discount Amount",
    Amount,
//     "Amount Including VAT",
//     "Allow Invoice Disc_",
//     "Inv_ Discount Amount",
//     "Gen_ Bus_ Posting Group",
    "Gen_ Prod_ Posting Group" as [Grupo contable inventario],
    "Unit Cost",
    "Line Amount",
    "Posting Date",
//     "Allow Line Disc_",
//     "Customer Disc_ Group",
    "_ Dto cabecera pedido",
    "Importe Dto_ Lin_ Factura"
//     "Order Date",
//     "Discount Code",
//     "Gross Amount"
FROM [lib://Miguel/Qlik\Luis.sales.invoice.line.2018.qvd]
(qvd);
Luis.hist.abono.venta:
LOAD
    "Document No_",
    "Sell-to Customer No_",
//     "Type",
    No_ as [Artículo],
    Quantity,
    "Unit Price",
    "Unit Cost (LCY)",
//     "VAT _",
    "Line Discount _",
    "Line Discount Amount",
    Amount,
//     "Amount Including VAT",
//     "Bill-to Customer No_",
    "Inv_ Discount Amount",
//     "Gen_ Bus_ Posting Group",
    "Gen_ Prod_ Posting Group" as [Grupo contable inventario],
    "_ Dto cabecera pedido",
    "Importe Dto_ Lin_ Factura"
//     "Discount Code",
//     "Gross Amount"
FROM [lib://Miguel/Qlik\Luis.hist.abono.venta.2019.qvd]
(qvd);
Concatenate (Luis.hist.abono.venta)
LOAD
    "Document No_",
    "Sell-to Customer No_",
//     "Type",
    No_ as [Artículo],
    Quantity,
    "Unit Price",
    "Unit Cost (LCY)",
//     "VAT _",
    "Line Discount _",
    "Line Discount Amount",
    Amount,
//     "Amount Including VAT",
//     "Bill-to Customer No_",
    "Inv_ Discount Amount",
//     "Gen_ Bus_ Posting Group",
    "Gen_ Prod_ Posting Group" as [Grupo contable inventario],
    "_ Dto cabecera pedido",
    "Importe Dto_ Lin_ Factura"
//     "Discount Code",
//     "Gross Amount"
FROM [lib://Miguel/Qlik\Luis.hist.abono.venta.2018.qvd]
(qvd);
 
Is giving me problems.
Best regards.
2 Solutions

Accepted Solutions
martinpohl
Partner - Master
Partner - Master

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

View solution in original post

Anil_Babu_Samineni

This should work - https://www.analyticsvidhya.com/blog/2014/12/remove-synthetic-key-concatenation-link-table-qlikview/

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

5 Replies
martinpohl
Partner - Master
Partner - Master

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

Godtooro
Contributor II
Contributor II
Author

Hi!

Thank you for your Support.

So, I´ve to concatenate the two tables at the same time?

Best regards.

martinpohl
Partner - Master
Partner - Master

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

Anil_Babu_Samineni

This should work - https://www.analyticsvidhya.com/blog/2014/12/remove-synthetic-key-concatenation-link-table-qlikview/

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Godtooro
Contributor II
Contributor II
Author

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.