New Entries

[#1]

Hi evrebody , Mensuelly i Load a table i want to show the new entries for example

JULY

ID	FIRST NAME	LAST NAME	DATE OF BIRTH
1	JAMES	MICKAEL	9.06.88
2	SHEPARD	LISA	1.09.93
3	LARGES	STEPHANIE	2.09.92

AUGUST :

ID	FIRST NAME	LAST NAME	DATE OF BIRTH
1	JAMES	MICKAEL	9.06.88
2	SHEPARD	LISA	1.09.93
3	LARGES	STEPHANIE	2.09.92
4	BEN	INESS	31.07.90

So i want a result like this

NEW ENTRIES :

ID	FIRST NAME	LAST NAME	DATE OF BIRTH
4	BEN	INESS	31.07.90

Thank u for help

[jagan]

Hi,

Data:

LOAD

*

FROM AugustData;

Concatenate(AugustData)

LOAD

*,

1 AS NewRecordFlag

FROM JulyData

WHERE NotExists(ID);

Now in the front end if you just want to see new records then use NewRecordFlag as filter and Select 1.

Regards,

Jagan.

[#3]

Jagan ,

Its doesnt work ,maybe because i have just one file with data of august and july

can you please see the attachement

[avinashelite]

Hi,

For the above logic to work you should have separate data file like one for today and one of tomorrow . You cannot use it on the same file

Regards,

@vi

[tresB]

There is a space between Not and Exists. So try like: WHERE Not Exists(@1);

[#6]

Hi,

We dont have a other suggestion to resolve my problem

[tresB]

As you are renaming the fields, try like:

WHERE Not Exists(@1, Pivot_NumeroSecuriteSocial )

[jagan]

Hi,

Try like this

Data:

LOAD

*

FROM TableName

WHERE Month='July';

Concatenate(Data)

LOAD

*,

1 AS NewRecordFlag

FROM TableName

WHERE Month='August';

AND  Not Exists(ID);

Now in the front end if you just want to see new records then use NewRecordFlag as filter and Select 1.

Regards,

Jagan.

[#9]

i dont have any element to identify  the month