Lesson 9 2B Revamped


#1

Hi,

Need a some help please, For lesson 9 practical 2 part B I am getting an error in my sequence for the Filter Data Table I am getting:

I´ve tried downloading the answer to see what they have done unfortunately im getting:
Answer

I have downloaded all the packages and read on the forum how to fix this issue, however hasnt worked (have downloaded all packages)

anyways so I am unable to check and compare our Filter Data Table to check if I have done exactly what they have said : “Use a Filter Data Table activity. Click on the Filter Wizard, add consolidatedDT as input and output, and select remove rows, because we want to get rid of the rows where the ID value is of less than 10.”

Here is a pic of my filter wizard
Wizard

So not entirely sure where the error comes in as it doesnt exactly tell you to set ColumnName? or not sure where to add it?


#2

@Tadrabs Give value “10” in double quotes


#3

@indra Thank you :slight_smile:

I did try that and am still having the same error

Wizard2


#4

what error you are getting now


#5

same one…


#6

It means column name is not fetching from excel check column name is there is any space


#7

Tanya,

For the “Read Range” activity, Please check if the “Add Headers” Property is checked ? If Not Please do make sure to checked and try again.


#8

yes, checked … no spaces :confused:


#9

Hi Mahesh,

yes I made sure to check headers… :slight_smile:


#10

Still the same error ?


#11

unfortunately…


#12

can you share your workflow


#13

Main.xaml (14.4 KB)


#14

can you share supported files


#15

Consolidate.xlsx (9.4 KB)
project.json (294 Bytes)


#16

Tanya,

Can you please make sure to check the “Add Headers” property for the “Write Range” Activity and try ?


#17

Check attached file and change excel path after downloading

Previously Issue was with write range changes as shown by @Mahesh_Lakshmipathy
pass number in floating format in filter data table value ex:10.0

Updated.xaml (14.1 KB)


#18

You are a shining star , thank you so much!


#19

Thank you so much Mahesh :slight_smile:


#20

@indra Dats Fantastic!! :slight_smile: