About sachin_32

sachin_32 · ‎03-02-2022

Thanks for the Help 🙂

sachin_32 · ‎03-02-2022

Hello @araujo Thank you so much for your Help Last Question if I have my attribute like :- INDEX 1,5,3,10 now what will be replacement value and in this case i have around 40 columns I want to rename only those which is present in my index Attribute and i want my column like 1,B,3,D,5---10,f,-- till 40 is there any way so that it don't depend on my all column name it's just replace the name as per the element in my INDEX attribute as it is and keep all columns without changing name??

sachin_32 · ‎03-02-2022

I have a use case where I want to Replace Value From My Attribute Like I have a Attribute Like :- 1. Header: A,B,C,D,E 2. Index: 3 Now I Want to replace the index Attribute Value from My header Attribute value with same Position like if I have 3 in my index attribute so it will replace the third aliment from my header attribute or if it's 5 so it should change the 5th one from header and make a new Attribute something like this Header_2 :- A,B,3,D,E Based on index attribute number it's needs to replace Thanks In Advance

sachin_32 · ‎03-01-2022

ok

sachin_32 · ‎03-01-2022

Thanks for your Suggestion but in this case i don't have any Exact Number of columns it will keep changing with incoming flow file it completely depends on the Flowfile And the scenario is i have few columns which can directly pick by giving the name of column but for some column which is coming more than one for that i need to setup like indexing and it's around 10-15 files which has this kind of issues so can you suggest for that ?

sachin_32 · ‎03-01-2022

I have the Flow File which has Duplicate Column i want to pick the Column threw index Number, is it possible to do with Query Record or any Processor Note: Column Will change with every new Flow File coming

sachin_32 · ‎01-31-2022

hi @MattWho , i checked with advance option also but wrong result is coming can you check this formula is it ok or not? ${mydate:toDate('MM/dd/yyyy'):format('u'):lt('6'):ifElse("${literal('6'):minus(${mydate:toDate('MM/dd/yyyy'):format('u')}):multiply('86400000'):minus(${mydate:toDate('MM/dd/yyyy'):toNumber()}):format('EEE,MM/dd/yyyy')}","${literal('518400000'):minus(${mydate:toDate('MM/dd/yyyy'):toNumber()}):format('EEE,MM/dd/yyyy')}")}

sachin_32 · ‎01-29-2022

the same way i am calculating previous Saturday but not able to get it can you help -------------------------- ${mydate:toDate('MM/dd/yyyy'):format('u'):lt('6'):ifElse("${literal('6'):minus(${mydate:toDate('MM/dd/yyyy'):format('u')}):multiply('86400000'):minus(${mydate:toDate('MM/dd/yyyy'):toNumber()}):format('EEE,MM/dd/yyyy')}","${literal('518400000'):minus(${mydate:toDate('MM/dd/yyyy'):toNumber()}):format('EEE,MM/dd/yyyy')}")}

sachin_32 · ‎01-28-2022

Hello Guys, How to Extract recent past Saturday based on today date and is there any expression language to get by update attribute

Online	Offline
Last Visited	‎12-02-2022 09:45 AM

Member Since	‎12-29-2021 01:47 AM
Last Visited	‎12-02-2022 09:45 AM
Posts	10
Kudos received	1

Cloudera Community

Re: Pick Column Based on Index Number

Re: Pick Column Based on Index Number

Replace Value From Attribute

Re: Pick Column Based on Index Number

Re: Pick Column Based on Index Number

Pick Column Based on Index Number

Re: how get next Week Sunday in NIFI

Re: how get next Week Sunday in NIFI

Extract Recent Past Saturday