Remove the last Row while processing

Hi Friends,

I am having the below scenario. The Last record needs to be removed since that is a Summarized of the Value field. I need to load the data into the database where all the fields are being declared as Key Fields and Nulls are not allowed. Please help me to solve this issue.

S.No	Name	Value	Country
1	Mike	200	USA
2	Jason	300	USA
		500

Output

Transformation

Accepted answers

anthony

add record id
sort desending on record id field
use "2-" in select record tool

Sort ascending and remove record ID.

Or just fliter out nulls/is empty from column 1.

rahuls

1. Use a Filter Tool and in its configuration select basic filter where Name Is Not Empty.

2. If you already know the number of records in your data, you can use Sample Tool as well.

All comments

anthony

add record id
sort desending on record id field
use "2-" in select record tool

Sort ascending and remove record ID.

Or just fliter out nulls/is empty from column 1.

rahuls

1. Use a Filter Tool and in its configuration select basic filter where Name Is Not Empty.

2. If you already know the number of records in your data, you can use Sample Tool as well.

MarqueeCrew

To remove the last row, use the sample tool and skip the last 1 record.

http://help.alteryx.com/10.6/index.htm#Sample.htm?Highlight=Sample

jackchoy

This seems like a useful feature to bundle in, since files with trailer records are a pretty common concept. Is there any possibility of building this into the standard Sample tool, instead of as a macro?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703