How to do Resident load from Inline load

[Rajitha1]

Hi Team,

I did Inline load i.e.

Load * INLINE [
Selector,SelectorId
Per NSR%,1
Per MT,2
];

from that Inline load how to do Max(SelectorId) as SelectNum1.

Thanks,

Rajitha

[ManuelRühl]

Hi,

Try this:

InlineTable:

Load * INLINE [

Selector,SelectorId

Per NSR%,1

Per MT,2

];

Max:

LOAD

MAX(SelectorId) as SelectNum1

RESIDENT InlineTable;

[Rajitha1]

Its not working

[ManuelRühl]

Did you name the initial inline table "InlineTable"?

[Rajitha1]

Yes. I did the same

InlineTable:
Load * INLINE [
Selector,SelectorId
Per NSR%,1
Per MT,2
];

Max:
LOAD
MAX(SelectorId) as SelectNum1
RESIDENT InlineTable;

[ManuelRühl · Accepted solution]

For me it works............ 🤔

[Rajitha1]

I need 3 columns in 1 table. I tried below one but it throws error.

Gross_Contribution1:
Load * INLINE [
Selector,SelectorId
Per NSR%,1
Per MT,2
];

Gross_Contribution:
Load *,
Max(SelectorId) as SelectNum1

Resident Gross_Contribution1;

Drop Table Gross_Contribution1;

[ManuelRühl]

Could you please provide some more information?

[Rajitha1]

I need 3 columns in 1 table means Selector,SelectorId,SelectNum1 . I tried below one but it throws error.

Gross_Contribution1:
Load * INLINE [
Selector,SelectorId
Per NSR%,1
Per MT,2
];

Gross_Contribution:
Load *,
Max(SelectorId) as SelectNum1

Resident Gross_Contribution1;

Drop Table Gross_Contribution1;

[ManuelRühl]

OK, can you please provide the desired output-Table?
Do you need the Max(SelectorID) per Selector or over all?