+ Reply to Thread
Results 1 to 11 of 11

Building a URL which Dynamically passes attributes based on grouping criteria

  1. #1
    Forum Contributor
    Join Date
    11-11-2011
    Location
    London, England
    MS-Off Ver
    EXCEL 2013
    Posts
    323

    Building a URL which Dynamically passes attributes based on grouping criteria

    Good Afternoon Team

    Hope all is well.

    I am hoping you can help me,

    Aim : Dynamically passing attributes to build a URL in column D.

    Example of URL :

    HTML Code: 
    https://emea.salesforce.com/merge/accmergewizard.jsp?goNext=+Next+&p2=001j000000hdOIW&cid=001j000000hdOIWAA2&cid=001j000000hdQb6AAE

    This part of the URL will always remain static ;
    HTML Code: 
    https://emea.salesforce.com/merge/accmergewizard.jsp?goNext=+Next+&p2
    Setting the master record
    HTML Code: 
    &p2=001j000000hdOIW
    The last segment is a collection of IDs. All use the parameter name of "&cid="

    HTML Code: 
    &cid=001j000000hdOIWAA2&cid=001j000000hdQb6AAE
    There are three columns which need to be referenced.

    Column A : ID(18 digits long)
    Column B: Grouping Mechanism
    Column C: Indicator of what record is Master

    Example 1

    3 Columns :
    Example1.JPG

    Column A : ID
    Column B : Group ID
    Column C :Outcome
    Column D: Full URL

    Scenario Logic

    Group ID = 21
    Outcome = Master
    Master id = A1


    URl Outcome:
    HTML Code: 
    https://emea.salesforce.com/merge/accmergewizard.jsp?goNext=+Next+&p2=001j000000hdOIW&cid=001j000000hdOIWAA2&cid=001j000000hdQb6AAE
    Example 2

    Example2.JPG
    Column A : ID
    Column B : Group ID
    Column C :Outcome
    Column D: Full URL

    Group ID = 25
    Outcome = Master
    Master id = A7

    URl Outcome:
    HTML Code: 
    https://emea.salesforce.com/merge/accmergewizard.jsp?goNext=+Next+&p2=001j000000hdSXY&cid=001j000000hdQc8AAE&cid=001j000000hdSXYAA2

    Please note that my data set is approx 2500 Rows

    I have attached example mock up example
    Attached Files Attached Files
    Last edited by masond3; 02-19-2020 at 10:20 AM. Reason: Adding Additional Details

  2. #2
    Forum Contributor
    Join Date
    11-11-2011
    Location
    London, England
    MS-Off Ver
    EXCEL 2013
    Posts
    323

    Re: Building a URL which Dynamically passes attributes based on grouping criteria

    *bump thread

  3. #3
    Forum Contributor
    Join Date
    11-11-2011
    Location
    London, England
    MS-Off Ver
    EXCEL 2013
    Posts
    323
    **bump thread

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,629

    Re: Building a URL which Dynamically passes attributes based on grouping criteria

    Good afternoon!

    Your thread has had 563 views since you first posted. That's quite a lot. There must be a reason why nobody has offered help, but just bumping a thread without asking if you need to offer more information is unlikely to change that. I will have a look at your attachment and see if I can see why you aren't getting any help.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,629

    Re: Building a URL which Dynamically passes attributes based on grouping criteria

    OK - I've had a look.

    I understand the basic premise of your request for help. However, I do not understand at all the designations and resulting sections of the URLs you are building. I think you need to explain these clearly in WORDS, as the examples alone are not speaking for themselves.

  6. #6
    Forum Contributor
    Join Date
    11-11-2011
    Location
    London, England
    MS-Off Ver
    EXCEL 2013
    Posts
    323
    Hi AliG,
    More than happy to provide additional details .
    I thought a member would of said could u explain xyz. But apologises I shlukd it took the Initiative and asked.
    Last edited by AliGW; 02-23-2020 at 12:06 PM. Reason: Please don't quote unnecessarily!

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,629

    Re: Building a URL which Dynamically passes attributes based on grouping criteria

    I have said above what I think is missing - perhaps start with that. We need to understand your logic.

  8. #8
    Forum Contributor
    Join Date
    11-11-2011
    Location
    London, England
    MS-Off Ver
    EXCEL 2013
    Posts
    323
    Okay i will try my best:
    High level I want to build a url that pre populated I’d based on the logic defined in three columns . The first part of the url remains static

    But what I would want help on is the following ;
    for a particular group I’d where the outcome column says “master” populate the id in column a of that particular group id

    This part of the url remains static

    &p2=

    However after the = the id of master record needs to be populated

    &p2=001j000000hdOIW p
    Last edited by AliGW; 02-23-2020 at 12:17 PM. Reason: Please don't quote unnecessarily!

  9. #9
    Forum Contributor
    Join Date
    11-11-2011
    Location
    London, England
    MS-Off Ver
    EXCEL 2013
    Posts
    323
    Just to note all the ids in column a are 18digits. However to populate the master id after &p2= I need the first 15 digits of the 18digit id in column a

    &p2=001j000000hdOIW

  10. #10
    Forum Contributor
    Join Date
    11-11-2011
    Location
    London, England
    MS-Off Ver
    EXCEL 2013
    Posts
    323

    Re: Building a URL which Dynamically passes attributes based on grouping criteria

    I have tried the following formula,

    =INDEX($A$2:A10,MATCH(1,(B2=B2:B10)*("Master"=$C$2:C10),0))

    The outcome for groupid 21 returns the value of '001j000000hdOIWAA2' which is correct.
    However for groupid 25 it should return 001j000000hdSXYAA2, but it still returns id of group master '001j000000hdOIWAA2'

  11. #11
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,629

    Re: Building a URL which Dynamically passes attributes based on grouping criteria

    Please attach the workbook you had prepared that has more information about the logic in it (you mentioned this in a duplicate thread).

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 6
    Last Post: 08-21-2019, 09:10 AM
  2. Grouping Names that Share Attributes (Huge? Data Set)
    By BANFSTC in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-05-2018, 09:24 PM
  3. Building list from database based on a date criteria
    By Tuppie in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-18-2014, 01:43 AM
  4. Replies: 12
    Last Post: 09-23-2012, 06:41 PM
  5. if value of x passes criteria then copy y
    By Office_Dummy in forum Excel General
    Replies: 11
    Last Post: 11-17-2011, 07:24 AM
  6. Replies: 3
    Last Post: 03-04-2010, 01:11 PM
  7. dynamically building references to named ranges
    By kadowd@gmail.com in forum Excel General
    Replies: 1
    Last Post: 01-03-2006, 06:23 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1