Creating Record IT and Get the total count of lines on Bottom

[jkorattiyil]

Hi everyone, I am looking for an easy way to create Record IT and Get the total count of lines on bottom. Anyone have any tips or easy way?

[binuacs]

@jkorattiyil @Can you provide a sample input file and expected output result?

[Prometheus]

@jkorattiyil If you're just trying to create a RecordID, you can use the RecordID tool. It's located in the Preparation palette.

 

[Peachyco]

Record ID is already a tool so you can just throw that in. The count of lines can be achieved via the Summarize tool, and then you can add it to the original dataset via the Union tool. Like this:

 

This is my starting data:

And this is the final data (I had to make some assumptions on which column you want the total to be under):

[jkorattiyil]

I am trying to join two table and if the joined lines count is 1 (in the below example) i wanted to change the name in table 1 to "B" instead of "A".

Taxble 1

Name

A

B

Taxble 2

Name

A

Expected result as follows.

Taxble 1

Name

B

and if the joined line if more than 1 i wanted to go as it is.

[Prometheus]

@jkorattiyil Check this out and see if it makes sense to you.

[jkorattiyil]

This one i checked, but it is converting everything to B. even if we have A and B on both table.

[Prometheus · Accepted solution]

@jkorattiyil Do you mean you're joining the tables to put them side by side or unioning them? In this one, I unioned the tables and counted rows by value and used a Formula tool to modify the value if the count > 1.