How yo avoid $SYNC tables

Godtooro — Fri, 21 Feb 2020 10:10:39 GMT

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.

Re: How yo avoid $SYNC tables

martinpohl — Fri, 21 Feb 2020 10:39:12 GMT

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

Re: How yo avoid $SYNC tables

Godtooro — Fri, 21 Feb 2020 10:41:33 GMT

Hi!

Thank you for your Support.

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

Best regards.

Re: How yo avoid $SYNC tables

martinpohl — Fri, 21 Feb 2020 10:45:00 GMT

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

Re: How yo avoid $SYNC tables

Anil_Babu_Samineni — Fri, 21 Feb 2020 10:49:51 GMT

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

Re: How yo avoid $SYNC tables

Godtooro — Fri, 27 Mar 2020 11:51:38 GMT

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.

topic Re: How yo avoid $SYNC tables in QlikView

How yo avoid $SYNC tables

Re: How yo avoid $SYNC tables

Re: How yo avoid $SYNC tables

Re: How yo avoid $SYNC tables

Re: How yo avoid $SYNC tables

Re: How yo avoid $SYNC tables