Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have such dataset
LOAD * Inline [
Name, Sign
WIND-SEP19, W
WIND-OCT18, W
WIND, W
WINDY, D
];
I need to process each row with the next logic: if there is a "-" I need to replace Name field value till this sign.
As the result I will have the next table
LOAD * Inline [
Name, Sign
WIND, W
WIND, W
WIND, W
WINDY, D
];
Coud you, please, tell how to apply such logic it in the load script?
Try this?
LOAD * Inline [
Name, Sign
WIND-SEP19, W
WIND-OCT18, W
WIND, W
WINDY, D
] Where Not WildMatch(Name, 'WIND-*');
Try this?
LOAD * Inline [
Name, Sign
WIND-SEP19, W
WIND-OCT18, W
WIND, W
WINDY, D
] Where Not WildMatch(Name, 'WIND-*');