topic condition in script in Integration, Extension & APIs

condition in script

zied_ahmed1 — Thu, 16 Mar 2017 09:05:15 GMT

I need to do the condition :

i have four fields:

car

date

parc

country

if i have one car in 2 differents parc in the same date i need to put these cars in flags

how to do it thanks

Re: condition in script

arockiyaselvana — Thu, 16 Mar 2017 10:58:23 GMT

Hi,

Try this...

Map_Count:

Mapping LOAD car&'-'&date as Key,

Count(parc) as Count

FROM File

Group By car, date;

Main_Table:

LOAD *,

If(Count>1,1,0) as Flag;

LOAD car,

date,

parc,

Applymap('ap_Count',car&'-'&date) as Count,

country

FROM File;

Pls let us know if your requirement is different.

Re: condition in script

chhavi376 — Thu, 16 Mar 2017 11:11:42 GMT

Hi Zied,

You can try this

Temp:

LOAD Car,

Date,

Parc,

Country

FROM

<<Your data source>>

Count1:

LOAD Car,

if(Count(DISTINCT Parc)>1,1,0) as Flag

Resident Temp group by Date,Car;

In your expression, you can write if sum(Flag)>0, 1,0

I hope this helps.

also, if you share the QVW with us, It would give a better clarity.

PFB: screenshots for better clarity

Re: condition in script

ahaahaaha — Thu, 16 Mar 2017 11:38:29 GMT

Hi,

Can be like this if I understood the task correctly?

Table1:

LOAD*Inline

[date, car, parc, country

01.01.2017, car1, parc1, country1

02.01.2017, car2, parc2, country2

03.01.2017, car3, parc3, country3

03.01.2017, car3, parc2, country3

04.01.2017, car1, parc1, country1

04.01.2017, car1, parc6, country1

04.01.2017, car1, parc2, country1];

Left Join

LOAD

date,

car,

If(Count(parc)>1, 1, 0) as Flag //

Resident Table1

Group By date,car;

Result

Regards,

Andrey

Re: condition in script

zied_ahmed1 — Thu, 16 Mar 2017 14:07:54 GMT

thanks for everybody i find another solution to resolve it