Need Some Inputs

Answered

Follow

shiva Karat

• December 18, 2019 16:19

I have 36 months data in a single  sheet.

I need to compare each month data for a particular field per say Client name and see who were added in the second month.

Need to do the same for first month and second month
then
second month and Third month
then
Third month and 4 month and so on

Can i do this in Datameer ?

 

0

• 

  Konsta Danyliuk

  • December 19, 2019 12:36

  Hello Shiva.
  If I properly understand the requirement, perhaps you could start from moving data for different months to separate Sheets, e.g.

  1. Create a duplicate of the Source Sheet.
  2. At this duplicated Sheet introduce a Filter to keep data for a certain month (e.g. January).
  3. Create one mode duplicate and add a Filter to get data for the next month (e.g. February) and so on...

  As soon as you have data separated by month, you could join Sheets with e.g. January and February by the required criteria.

  You also might want to review the following sections of Datameer documentation.

  • Filtering Data
  • Joining Data

  In case my understanding of the use-case is wrong, please provide more details, preferably with samples of the source data and desired results.

  0

  Comment actions Permalink
• 

  shiva Karat

  • December 20, 2019 04:19
  • Edited

  Thank you for quick reply

  Much Appreciated

  Thank you Danyliuk

   

  can you please let me know how to do the below

   

  I have below requirement can you tell me how to do it in datameer

   

  Company_A    Company_B   My_Column
  ABC                  ABC                   Existing
                           ABC                    W
  ABC                                              L
  
  

   

  If company_A is equal to Company_B i need to calculate a new column called My_Column and write Existing in it.

   

  If company_A is empty and Company_B has any value the i need to write a W in my new column

   

  If a company_A has a value and Company_B has nothing then i need to write L in my new column

  
  
  
  

   

   

  0

  Comment actions Permalink
• 

  Konsta Danyliuk

  • December 20, 2019 09:12

  Hello Shiva.
  I guess the easiest way, in this case, to use a set of IF functions.

  For example, you have the following input data.

  

  To compare whether values in FirstCompany and SecondCompany columns are equal, simply use #FirstCompany == #SecondCompany, this expression returs true or flase.

  To find out whether FirstCompany or SecondCompany columns have values, use ISBLANK function e.g. ISBLANK(#FirstCompany). It also returns true or false. 

  Now you could use the IF function to put generate value in a new column based on the desired condition.

  IF(#FirstCompany == #SecondCompany;"Existing";null) - this formula puts Existing into a new column in case the FirstCompany name equals the SecondCompany name and returns nothing (null) in case the otherwise.

  And, of course, you could use nested IFs to have more conditions included.

  The following formula will return:

  1. Existing in case the value in the FirstCompany column equals the value in the SecondCompany column.
  2. L in case the FirstCompany exists and the SecondCompany is empty
  3. W in case the SecondCompany exists and the FirstCompany is empty
  4. nothing (null) in case values exist in both columns but they are not equal (it seems you haven't covered this case in your description).

  IF(#FirstCompany == #SecondCompany;"Existing";IF(ISBLANK(#FirstCompany);"W";IF(ISBLANK(#SecondCompany);"L";null)))

  

  I hope this information helps you to proceed further with the use-case.

   

  0

  Comment actions Permalink
• 

  shiva Karat

  • December 20, 2019 20:56

  I'm pretty new to Datameer.

  Thanks for helping me out Danyliuk !!

   

   

  0

  Comment actions Permalink
• 

  Konsta Danyliuk

  • December 22, 2019 17:16

  You are welcome, Shiva.
  If you will have any further questions on this topic, please do not hesitate to ask.

  0

  Comment actions Permalink

Please sign in to leave a comment.