Nick name generator using data table


#1

I am trying to resolve an issue
Create a sequence that does the following:
Reads a file called ‘Members Only.csv’(read CSV) and stores the data in a data table (Build Data Table). Filters the data table based on whether the person is a club member (Filter Data Table). Creates a nickname for each club member using the first 3 letters of the first name, all in uppercase, and the first 3 letters of the last name, all in lowercase (for each row in filter table assign nickname=FName.Substring(0,3).ToUpper & LName.Substring(0,3).ToLower). Writes all the generated nicknames to the Output Panel (write line).
I have written the code but it’s not giving any error or expected output. Basically it’s not giving any output or error. Can you please suggest what am I missing here.

Thanks
Pallvi


#2

@Pallvi Is it possible to share your work flow?


#3

Hi Pallvi,

You don’t need the Build Data Table activity. The Read CSV activity will output a datatable based on the CSV content. If you have a Build Data Table after the Read CSV, the datatable generated from CSV file will be recreated with no data in it.

Regards
Silviu


#4

Main.xaml (9.6 KB)