JOIN .csv FILES (Following rules)

Description du projet

Create a [url removed, login to view] file uniting the following files.

FILES TO UNITE:

01 - TALLO - [url removed, login to view]

02 - MASNOU - [url removed, login to view]

03 - OPENFOOD - [url removed, login to view]

04 - AECOC - [url removed, login to view]

05 - CODROPER - [url removed, login to view]

06 - MERCADONA - [url removed, login to view]

07 - PHARMA - [url removed, login to view]

08 - CONDIS - [url removed, login to view]

09 - CARREFOUR - [url removed, login to view]

10 - DESPENSA - [url removed, login to view]

11 - ALCAMPO - [url removed, login to view]

12 - VINATERIA - [url removed, login to view]

Download from: [url removed, login to view] (.zip file / 16Mb)

IMPORTING ORDER.

When creating the [url removed, login to view] follow this importing order.

- First, import file 01 - TALLO - [url removed, login to view]

- Second, import file 02 - MASNOU - [url removed, login to view]

- Thirdm import file 03 - OPENFOOD - [url removed, login to view]

...

- Last, import file 12 - VINATERIA - [url removed, login to view]

IMPORTING RULES:

The files should be united by EAN

The EAN will be like and UNIQUE ID.

An EAN will appear only in one row --> NO repeated EANS in different rows.

HOW TO PROCEED: (VERY IMPORTANT)

Before importing the row you have to check if the EAN exists in [url removed, login to view]

- If EAN do not exist --> Create the NEW row with the values of the columns.

- If EAN exist --> Update Values OVERWRITE EXISTING values. (We substitute old values for new ones if there is text in the cell)

If the value of the cell is NILL OR NULL OR "" OR VOID or FALSE --> We do not update that specific value, we do NOT OVERWRITE

All files have these columns.

A=EAN

B=NAME

C=BRAND

D=IMG_LARGE

E=IMG_SMALL

F=SIZE

G=CATEGORY

H=DESC

I=COMPANY

EAN Column: All of them have a value.

Rest of columns: some have values, some not.