i wanted to reduce rows while loading from excel. I tried Using enable transformation and conditional delete but I ended up with a code as below,
(ooxml, embedded labels, table is Sheet1, filters(
Remove(Row, RowCnd(Interval, Pos(Top, 2), Pos(Top, 3), Select(1, 3)))
Can someone explain how it works ?
One more doubt is, how do I load only the data like this as output ?
Output: ONLY THE PARTICULAR FIELDS WITH DATA:
If you don't want the member_biz_key field, just remove it from the LOAD statement.
What's the rule behind loading only these two rows? Is it based on age, gender, both or row number?
It is like just an example that i want to load only the particular data. i.e;data from A1 to C5 in above table - Load only from cell B4(age 30) in excel to C5(gender D) removing A column and first 2 records of B cells and C cells as well..